Define the Table Relationships
Table Relationships: Two Tables can be related, or joined, if there is at least one Field in both Tables that matches.
When two Tables have a matching Field you can look up the answer in one Table and save it to another.
In Microsoft Access, a Combo Box looks up the answers in a Table. We played with the Products Form earlier at the beginning of this lesson.
Tables can be related, or joined, in Microsoft Excel as well. The Relationships may be inherited from the database when the Tables are linked or imported. The Relationships can also be defined.
Here are the steps to manage Table Relationships.
Start Here: The PivotChart on the PivotChart2 spreadsheet is still selected.
The PivotChart Tools are available.
6.
Try This: Define the Table Relations
Go to PivotChart Tools->Analyze->Calculations.
Click on Relationships.
Keep going...
